"VER1.0","Articulos","Estadstica albaranes no facturados"
;Versio, Categoria, Descripcion

;Ampla, Llarg, [EspaiCos]
;MargenX,MargenY, EtiLin, EtiPag
[DOCUM]
0, 0, 0
0, 0, 0, 0
; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
1,"CABECERA", #FALSE#
"SELECT * , CodigoPostal & ' - ' & Poblacion as Direc, 'Tel : ' & Telefono1 as Tel "
"FROM Configuracion"
""
[CAPSALERA]
0, 0, #FALSE#, 0, #FALSE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 4
3,"CABECERA","NombreComercial",10,3,"ARIAL",14,0,0,"1000",""
3,"CABECERA","Nif",10,12,"ARIAL",8,0,0,"1000",""
0,"Condiciones : ",20,20,"ARIAL",8,0,0,"1000"
6,"Condiciones",45,20,"ARIAL",8,0,0,"1000",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 2
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 0
;0,"Total General",160,0,"ARIAL",12,0,1,"1000"
;5,0,"Total",170,0,"ARIAL",10,0,0,"1000","Total"
[FIPEU]
[FIGRUP]

;-----------------------------------------


; Tipo, NomGrup, InicNumPag,   Select, From, GropBy
[GRUP]
0, "GENERAL", #FALSE#
""
""
""
;[ordenaciones] y [condiciones]
[CAPSALERA]
0, 30, #TRUE#, 0, #TRUE#, #TRUE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 13
0,"Estadstica albaranes no facturados",45,14,"ARIAL",16,0,0,"1001"
0,"Pgina :",165,5,"ARIAL",8,0,0,"1000"
6,"Pagina",195,5,"ARIAL",8,0,1,"1000",""
0,"Fecha :",165,10,"ARIAL",8,0,0,"1000"
6,"Fecha",195,10,"ARIAL",8,0,1,"1000",""
1,"linea2",5,24,195,24,,,
1,"linea1",5,29,195,29,,,
0,"Codigo",15,25,"ARIAL",8,0,0,"1000"
0,"Descripcin",30,25,"ARIAL",8,0,0,"1000"
0,"Unidades",135,25,"ARIAL",8,0,1,"1000"
0,"Cajas",150,25,"ARIAL",8,0,1,"1000"
0,"Precio Medio",175,25,"ARIAL",8,0,1,"1000"
0,"Valor",195,25,"ARIAL",8,0,1,"1000"
[FICAP]

[PEU]
0, 10, #FALSE#, 0, #FALSE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 3
1, "Cuadro", 140, -2, 198, 8, 1, 0,
0,"Total General :",150,0,"ARIAL",10,0,0,"1000"
5,0,"TotalG",195,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]

[FIGRUP]

;-----------------------------------------


;tipo, NomGrup, Select, From, GropBy
[GRUP]
2,"CAB2", #FALSE#
"SELECT CodFamilia & ' - ' & Descripcion as Titulo2, * "
"FROM Familias"
""
[ORDENACIONS] 1
"CodFamilia", "Codigo Familia", 3

[CONDICIONS] 2
"CodFamilia", "Cod. Familia", 0, 1
"Descripcion", "Descripcin", 0, 1

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 1
3,"CAB2","Titulo2",5,0,"ARIAL",10,0,0,"0001",""
[FICAP]

[PEU]
0, 10, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 2
0,"Total :",160,0,"ARIAL",10,0,0,"1000"
5,0,"TotalP",195,0,"ARIAL",10,0,1,"1000","Total"
[FIPEU]
[FIGRUP]



;tipo, NomGrup, Select, From, GropBy
[GRUP]
3,"COS", #FALSE#
" SELECT VenAlba.Facturado, First(VenAlba.FechaAlbaran) AS FechaAlbaran, Articulos.UnidadBulto , VenAlbaLin.CodArticulo, First(VenAlbaLin.Descripcion) AS Descripcion, Articulos.CodFamilia, Sum(VenAlbaLin.Cantidad) AS TotalCantidad, TotalCantidad / Articulos.UnidadBulto as Cajitas, Sum(Precio*Cantidad) AS Valor, Valor / TotalCantidad as PrecioMedio "
" FROM (VenAlba INNER JOIN VenAlbaLin ON (VenAlba.CodCliente = VenAlbaLin.CodCliente) AND (VenAlba.NumAlbaran = VenAlbaLin.NumAlbaran) AND (VenAlba.Seccion = VenAlbaLin.Seccion)) INNER JOIN Articulos ON VenAlbaLin.CodArticulo = Articulos.CodArticulo "
" GROUP BY VenAlba.Facturado, VenAlbaLin.CodArticulo, Articulos.CodFamilia, Articulos.UnidadBulto "
[CONDICIONS] 4
"CodFamilia", "CodFamilia", 1, 1, "CAB2", "CodFamilia"
" ( Facturado= false) ","",4
" (VenAlbaLin.CodAlmacen = '1') ","",4
" FechaAlbaran","Fecha",0,2

[CAPSALERA]
0, 5, #TRUE#, 0, #TRUE#, #FALSE#, 0
; RAp(n), Alt(n), SMin(b), Salto(D), GA(b), All(b), Rel(D)
[CAMPS] 6
3,"COS","CodArticulo",12,0,"ARIAL",8,0,0,"0000",""
3,"COS","Descripcion",36,0,"ARIAL",8,50,0,"0000",""
3,"COS","TotalCantidad",135,0,"ARIAL",8,0,1,"0000",""
3,"COS","Cajitas",150,0,"ARIAL",8,0,1,"0000","###,###;;\ ---"
3,"COS","PrecioMedio",175,0,"ARIAL",8,0,1,"0000","Precio"
3,"COS","Valor",195,0,"ARIAL",8,0,1,"0000","Total"
[FICAP]
[FIGRUP]

[CALCULS] 2
"TotalP","COS","Valor","CAB2"
"TotalG","COS","Valor","GENERAL"

[FIDOCUM]


